{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["EES_SDEP_Req_CoverSheet","ALL EES Reqs","ALL SDEP Reqs"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"EES_SDEP_Req_CoverSheet","index":0,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Version ","Description ","Author",null,"Date"]
[null,"v0.1","Draft","MHHS Design Team",null,"2022-07-01"]
[null,"v0.2","Updated with Annual Quantity ","MHHS Design Team",null,"2022-07-27"]
[null,"v3.0","Tranche 4 release","MHHS Design Team",null,"2022-08-08"]
[null,"v3.5","Issued for Industry Review","MHHS Design Team",null,"2022-10-14"]
[null,"v4.0","DAG Baseline","MHHS Design Team",null,"2022-10-31"]
[null,"v4.5","Issued for Work-off plan assurance review","MHHS Design Team",null,"2022-12-16"]
[null,"v4.6","Issued for DAG review (No change from v4.5)","MHHS Design Team",null,"2023-01-20"]
[null,"v5.0","DAG Baseline","MHHS Design Team",null,"2023-02-16"]
[null,"v6.0","RECCo CR Update","RECCo",null,"2023-06-28"]
[]
[null,"The Electricity Enquiry Service (EES) is the name for the online enquiry service and associated API formally known as the Electricity Central Online Enquiry Service (ECOES)"]
[null,"This document provides additional MHHS Requirements for EES. Note unless specified otherwise all existing EES requirements held within the Retail Energy Code will remain"]
[null,"Please note that a Glossary of Terms and Acronyms used by the MHHS Programme is available on the MHHS Website"]
[null,"www.mhhsprogramme.co.uk"]

{"sheet":"ALL EES Reqs","index":1,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Reference","Area","Requirement","Requirement Description","Supporting information/ questions","Process","Step","Interface","CR Comment"]
[null,"Data - EES (ECOES) requirements"]
[null,"MHHS-BR-EES-001","EES (ECOES)","View Connection Type data","EES (ECOES) should allow visibility to all parties of the Connection Type and Effective From Date for an MPAN "]
[null,"MHHS-BR-EES-002","EES (ECOES)","View Market Segment Data","EES (ECOES) should allow visibility to all parties of the Market Segment, Effective From Date and Market Segment Valid flag for an MPAN "]
[null,"MHHS-BR-EES-003","EES (ECOES)","View appointed Supplier DIP ID","EES (ECOES) should allow visibility to all parties of the Supplier DIP ID and Supplier DIP EZ Name for an MPAN",null,null,null,null,"DIP EZ Name no longer included in MHHS design"]
[null,"MHHS-BR-EES-004","EES (ECOES)","View appointed LDSO DIP ID","EES (ECOES) should allow visibility to all parties of the LDSO DIP ID and LDSO DIP EZ Name for an MPAN",null,null,null,null,"DIP EZ Name no longer included in MHHS design"]
[null,"MHHS-BR-EES-005","EES (ECOES)","View Metering Service appointed","EES (ECOES) should allow visibility to all parties of the Metering Service DIP ID, Metering Service DIP EZ Name  and the Effective From Date for an MPAN",null,null,null,null,"DIP EZ Name no longer included in MHHS design"]
[null,"MHHS-BR-EES-006","EES (ECOES)","View Data Service appointed","EES (ECOES) should allow visibility to all parties of the Data Service DIP ID, Data Service DIP EZ Name and the Effective From Date for an MPAN",null,null,null,null,"DIP EZ Name no longer included in MHHS design"]
[null,"MHHS-BR-EES-007","EES (ECOES)","View Customer Direct Contract Flag - Metering Service","EES (ECOES) should allow visibility to all parties of the Metering Service Customer Direct Contract Flag for an MPAN "]
[null,"MHHS-BR-EES-008","EES (ECOES)","View Customer Direct Contract Flag - Data Service","EES (ECOES) should allow visibility to all parties of the Data Service Customer Direct Contract Flag for an MPAN "]
[null,"MHHS-BR-EES-009","EES (ECOES)","View Metering Service with Customer Direct Contract Flag","EES (ECOES) should allow visibility to the Registered Supplier of the Metering Service that has set the Customer Direct Contract Flag for an MPAN "]
[null,"MHHS-BR-EES-010","EES (ECOES)","View Data Service with Customer Direct Contract Flag","EES (ECOES) should allow visibility to the Registered Supplier of the Data Service that has set the Customer Direct Contract Flag for an MPAN "]
[null,"MHHS-BR-EES-011","EES (ECOES)","View Energy Direction","EES (ECOES) should allow visibility to all parties of the Energy Direction for an MPAN"]
[null,"MHHS-BR-EES-012","EES (ECOES)","View Meter Manufacturer","EES (ECOES) should allow visibility to all parties of the Meter Manufacturer for an MPAN"]
[null,"MHHS-BR-EES-013","EES (ECOES)","View linked Import/Export MPANs","EES (ECOES) should allow visibility to all parties of any linked Import/Export MPANs"]
[null,"MHHS-BR-EES-014","EES (ECOES)","View linked Export Supplier DIP ID and DIP EZ Name ","EES (ECOES) should allow visibility to Registered Supplier of any Export Supplier for linked Export MPANs for an Import MPAN"]
[null,"MHHS-BR-AC-010","EES (ECOES)","View Annual Consumption Data","EES (ECOES) should allow visibility to all parties of the Annual Consumption, Annual Consumption Effective Date and Annual Consumption Quality for an MPAN","Added from Annual Consumption requirements"]
[null,"MHHS-BR-EES-023","EES (ECOES)","Add DUOS ID & DUOS ID Eff From Date","EES (ECOES) should allow visibility to all parties of the DUoS Tariff ID Effective Date and DUoS Tariff ID for an MPAN"]
[null,"General - EES (ECOES) requirements"]
[null,"MHHS-BR-EES-015","EES (ECOES)","Access for new TOM parties","EES (ECOES) should allow access to Metering Services and Data Services"]
[null,"MHHS-BR-EES-017","EES (ECOES)","Search using Meter Serial Number (Meter Details)","EES (ECOES) should allow searches by Meter Serial Number to Meter Manufacturer and Meter Type to be displayed","LDSOs require MSN lookup API \nManufacture & Meter Type",null,null,null,"Searching by MSN on the web portal is current functionality. A meter only API would be significant and costly change to the API solution not justified by MHHS consequential change."]
[null,"MHHS-BR-EES-018","EES (ECOES)","Search using Meter Serial Number (MPAN)","EES (ECOES) should allow searches by Meter Serial Number to allow MPAN details to be displayed",null,null,null,null,"Searches by MSN are part of current functionality"]
[null,"Possible EES Data Requirements to support DIP Initialisation "]
[null,"MHHS-BR-EES-019","EES (ECOES)","Initial population of tables for DIP routing","EES (ECOES) could be used as a source of data to support the initial population of DIP tables for each MPAN:\nCurrent Supplier & SSD\nCurrent Registration Service \nDistributor ID and GSP ID","Subject to further discussion on Transition",null,null,null,"This is not a requirement within the Transition or Migration design."]
[null,"MHHS-BR-EES-020","EES (ECOES)","Provide data for reconciliation","EES (ECOES) could be used to provide data to Suppliers to support reconciliation of data between all parties","Monthly snapshot, part of portfolio each day…",null,null,null,"No additonal reporting requirements identified through the Data Cleanse process."]
[null,"Update Timing Requirements"]
[null,"MHHS-BR-EES-016.1","EES (ECOES)","Data items updated on Secured Active","EES (ECOES) must ensure Data Items identified as to be updated off the back of Secured Active (Ref Data matrix in the Interface Data Item catalogue) should be updated & visible in EES before 6am the following working day once published in the DIP as per the Operational Choreography","Bulk PUB-01/PUB-036",null,null,null,"EES will update Supplier Registration information through a direct CSS interface rather than via the IF-001"]
[null,"MHHS-BR-EES-016.2","EES (ECOES)","Data items updated in real time","EES (ECOES) must ensure Data Items identified as 'real time maintained'  (Ref Data matrix in the interface Data Item catalogue ) should be updated and visible in EES, within 2hrs of the update being completed in the Registration Service relevant Publication being received from the DIP ","See EES-016.3"]
[]
[null,"DIP Interface to be processed - EES (ECOES) requirements"]
[null,"MHHS-BR-EES-016.3","EES (ECOES)","Receive MHHS Publication ","EES (ECOES) should obtain the following MHHS Publications so as to allow maintenance of key data items within EES (ECOES):\nPUB-001, PUB-006, PUB-008, PUB-009, PUB-018, PUB-020, PUB-026, (PUB-035), PUB-036, PUB-037, PUB-039, PUB-040, PUB-043, PUB-044, PUB-050",null,null,null,null,"EES will update Supplier Registration information through a direct CSS interface rather than via the IF-001"]
[null,"MHHS-BR-EES-016.4","EES","Receive CSS Publications","EES should obtain relevant CSS interfaces to allow it update Supplier registration information and history",null,null,null,null,"EES will update Supplier Registration information through a direct CSS interface rather than via the IF-001"]
[null,"MHHS-BR-EES-016.5","EES","Update ISD Data","EES should obtain the PUB-047 to receive updates of ISD Change and be able to access the URI provided in the IF-047 to obtain the updated tables","PUB-047"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"​"]

{"sheet":"ALL SDEP Reqs","index":2,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,"Area","Requirement","Requirement Description","Supporting information/ questions","Process","Step","Interface","CR Comment"]
[null,"General - SDEP requirements",null,null,null,null,"General - SDEP requirements"]
[null,"MHHS-BR-EES-021","SDEP","Remove redundant DTC flow references","SDEP should have existing processes updated where reference is made to an existing data flow that is removed by MHHS",null,null,null,null,"Covered as part of consequential change"]
[null,"MHHS-BR-EES-022","SDEP","Add new parties","SDEP should allow access to Metering Services and Data Services ( subject to agreement on new processes ). ","Currently Suppliers and Distributors only. Meter Equipment Managers for crossed meters. ",null,null,null,"Not required"]
[null,"Process - SDEP requirements",null,null,null,null,"Process - SDEP requirements"]
[null,"MHHS-BR-EES-023","New Metering Point Request","Update New Metering Point Request process ","The New Metering Point Request Process should allow capture of:\n   - Connection Type\n   - Proposed Segment\n   - Unmetered Flag\n   - Energy Direction \n   - Import / Export MPAN linkages",null,null,null,null,"Covered as part of consequential change"]
[null,"MHHS-BR-EES-024","SDEP","Energisation query","SDEP could introduce a new process to allow Suppliers/ Data Services/Metering Services to query energisation status with the Metering Service ",null,null,null,null,"Not required"]
[null,"MHHS-BR-EES-025","SDEP","Meter Technical Details query","SDEP could introduce a new process to allow Suppliers/ Data Services/Metering Services to query MTDs with the Metering Service ",null,null,null,null,"Not required (being considered as part of the R0006 solution)"]
[null,"MHHS-BR-EES-026","SDEP","Meter Technical Details delivery query","SDEP could introduce a new process to allow Suppliers/ Data Services/Metering Services to query non receipt of MTDs with the Metering Service ",null,null,null,null,"Not required (being considered as part of the R0006 solution)"]
[null,"MHHS-BR-EES-027","SDEP","Estimated Meter Read delivery query","SDEP could introduce a new process to allow Suppliers/ Data Services to query non receipt of an estimated meter read with the Data Service ",null,null,null,null,"Not required"]
[null,"MHHS-BR-EES-028","SDEP","Consumption on de-energised site","SDEP could introduce a new process to allow Suppliers/ Data Services to query consumption on a de-energised site with the Metering Service ",null,null,null,null,"Not required"]
[null,"MHHS-BR-EES-029","SDEP","Export/Import linkage","SDEP could introduce a new process to allow Suppliers to request change to the Export/Import linkage",null,null,null,null,"Not required"]
[null,"MHHS-BR-EES-030","SDEP","UMS MPAN creation","SDEP could introduce a new process to allow UMSOs to request set up of the MPAN by LDSOs",null,null,null,null,"Not required"]
[null,"MHHS-BR-EES-031","SDEP","UMS site address update","SDEP could introduce a new process to allow UMSOs to request LDSO to change a site address",null,null,null,null,"Not required"]
[null,"MHHS-BR-EES-032","SDEP","UMS disconnection","SDEP could introduce a new process to allow UMSO's, LDSO's to coordinate disconnection requests for a UMS MPAN",null,null,null,null,"Not required"]
[null,"MHHS-BR-EES-033","SDEP","Agree change of connection/ segment work","SDEP could introduce a new process to allow Suppliers to request and agree work from LDSO's and Metering Services for a change of connection type/ market segment",null,null,null,null,"Not required"]
[null,"MHHS-BR-EES-034","SDEP","Metered Indicator update","SDEP could introduce a new process to allow Suppliers to request LDSO to carry out the one time change to Metered Indicator",null,null,null,null,"Not required"]
[null,"MHHS-BR-EES-035","SDEP","Energy Direction update","SDEP could introduce a new process to allow Suppliers to request LDSO to carry out the one time change to Energy Direction",null,null,null,null,"Not required"]